<html>
<?php
//connection
	$con = mysql_connect("localhost","dev","homesurf");
	if (!$con)
	{
		die('Could not connect: ' . mysql_error());
	}
	mysql_select_db("homesurf", $con);
?>

<body>
	<table border="1">
<?php	
	$result = mysql_query("SELECT AddressID, City FROM listings");
	while($row = mysql_fetch_array($result))
	{
		echo "<tr><td>AddressID</td><td>" . $row[0] . "</td></tr>";
		echo "<tr><td>City</td><td>" . $row[1] . "</td></tr>";
	   echo "<br />";
	}
?>	
	</table> 

</body>
<?php
	mysql_close($con);
?>
</html>